/* ***************** Log Table ********************* */
if exists (select * from sysobjects where id = object_id('dbo.[sys_Log]'))  
	drop table [sys_Log]
GO

Create Table [sys_Log]
(
	[ID] int identity(1,1) not null,
	[Time] datetime not null,				 
	[User] nvarchar(20)	not null,	 		 
	[Type] nvarchar(20)	not null,	 
	[Name] nvarchar(20)		null,
	[Desc] nvarchar(Max)	null,		 
	[Path] nvarchar(1024)	null,	
	[From] nvarchar(20)		null,  
	CONSTRAINT PK_sys_Log PRIMARY KEY NONCLUSTERED ([ID]) 
)
GO

 